package com.bw.gmallpublisher.mapper;

import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

public interface GmvMapper {

    //查询日交易总额
    @Select("select  sum(order_amount)  from    dws_trade_province_order_window   where  toYYYYMMDD(stt)=#{date}")
    public BigDecimal getGmv(int date);
}
